Project: Investigating Ford's go-Bike Trips Data (2019)

Table of Contents

Introduction

Data Wrangling

Tip: In this section of the report, I will load in the data, check for cleanliness, and then trim and clean the dataset for analysis.

General Properties

Well I don't think I am going to use the longitude nor the latitude in my analysis so i'm gonna drop those :)

There appear to be alot of missing values. However it's understandable since it's in the gender & age columns as many people prefer to not disclose their gender nor their age, so we're gonna just fill those with the mean for each column :)

Also there is an outlier in the age column as someone decided to put their birth year 1878 :'D

There is just some missing id's so we're gonna drop those :)

Now The data is nice and clean :D

Exploratory Data Analysis

Research Question 1

$What$ $are$ $the$ $stations$ $with$ $the$ $longest$ $duration$ $?$

It appears from the previous tables that the longest recorded trips were between Powell St BART Station & both of (Myrtle St at Polk St & Valencia St at 16th St)

Research Question 2

$Does$ $the$ $user's$ $Gender$ $affect$ $duration$ $of$ $the$ $trip$ $?$

Research Question 3

$Does$ $the$ $user's$ $type$ ($Either$ $'Customer'$ $or$ $'Subescriber'$) $affect$ $the$ $duration$ $of$ $the$ $trip$ $?$

Research Question 4

$Does$ $the$ $user's$ $age$ $affect$ $the$ $duration$ $of$ $the$ $trip$ $that$ $user$ $takes$ $?$

We need to adjust the bins for a better look :)

It's clear from the previous graph that most of the users are born between 1980 and 1990, which means the majority are adults between 31 to 41 years old.

There appears a teeny tiny (expected) relation betweeen age and duration of the trip since the longer durations are from users of younger age (usually).

Research Question 5

$What$ $are$ $the$ $females$ $proportion$ $from$ $the$ $total$ $adults $from$ $the$ $previous$ $graph$ $?$

The most durations recorded are nearly in the range of 100 ~ 2000 Seconds by the three genders :)

Conclusions

Limitations